{% set table_size = 15 -%}
{% for join_algorithm in ['default', 'full_sorting_merge', 'grace_hash'] -%}
-- {{ join_algorithm }} --
{% for block_size in range(1, table_size + 1, 4) -%}
ALL INNER USING | bs = {{ block_size }}
4	0	0
5	0	0
6	0	0
8	0	0
9	0	0
11	0	0
11	0	0
12	0	0
13	0	0
13	0	0
13	0	0
14	0	0
14	0	0
ALL INNER | bs = {{ block_size }}
4	4	0	0
5	5	0	0
6	6	0	0
8	8	0	0
9	9	0	0
11	11	0	0
11	11	0	0
12	12	0	0
13	13	0	0
13	13	0	0
13	13	0	0
14	14	0	0
14	14	0	0
ALL LEFT | bs = {{ block_size }}
1	0	val7	1
2	0	val3	1
2	0	val5	1
4	4	val0	0
5	5	val12	0
6	6	val11	0
8	8	val4	0
9	9	val10	0
10	0	val1	1
10	0	val14	1
11	11	val6	0
11	11	val8	0
12	12	val2	0
13	13	val13	0
13	13	val13	0
13	13	val13	0
14	14	val9	0
14	14	val9	0
ALL RIGHT | bs = {{ block_size }}
4	4	0	val10
5	5	0	val6
6	6	0	val8
8	8	0	val1
9	9	0	val5
11	11	0	val11
11	11	0	val11
12	12	0	val0
13	13	0	val2
13	13	0	val4
13	13	0	val9
14	14	0	val3
14	14	0	val7
ALL INNER | bs = {{ block_size }} | copmosite key
2	2	2	2	2	2	0	0
2	2	2	2	2	2	0	0
ALL LEFT | bs = {{ block_size }} | copmosite key
1	1	2	0	0	\N	val14	1
1	1	2	0	0	\N	val3	1
1	2	1	0	0	\N	val7	1
1	2	2	0	0	\N	val1	1
1	2	2	0	0	\N	val13	1
1	2	2	0	0	\N	val4	1
1	2	2	0	0	\N	val8	1
1	\N	1	0	0	\N	val0	1
1	\N	1	0	0	\N	val5	1
1	\N	2	0	0	\N	val10	1
2	2	1	0	0	\N	val11	1
2	2	1	0	0	\N	val2	1
2	2	1	0	0	\N	val6	1
2	2	2	2	2	2	val12	0
2	2	2	2	2	2	val9	0
ALL RIGHT | bs = {{ block_size }} | copmosite key
0	\N	0	1	1	1	1	val2
0	\N	0	1	1	1	1	val7
0	\N	0	1	1	2	1	val5
0	\N	0	1	1	\N	1	val0
0	\N	0	1	1	\N	1	val6
0	\N	0	2	1	1	1	val1
0	\N	0	2	1	1	1	val11
0	\N	0	2	1	2	1	val10
0	\N	0	2	1	2	1	val8
0	\N	0	2	1	\N	1	val3
0	\N	0	2	2	\N	1	val9
2	2	2	2	2	2	0	val4
2	2	2	2	2	2	0	val4
ANY INNER USING | bs = {{ block_size }}
4	0	0
5	0	0
6	0	0
8	0	0
9	0	0
11	0	0
12	0	0
13	0	0
14	0	0
ANY INNER | bs = {{ block_size }}
4	4	0	0
5	5	0	0
6	6	0	0
8	8	0	0
9	9	0	0
11	11	0	0
12	12	0	0
13	13	0	0
14	14	0	0
ANY LEFT | bs = {{ block_size }}
1	0	val7	1
2	0	val3	1
2	0	val5	1
4	4	val0	0
5	5	val12	0
6	6	val11	0
8	8	val4	0
9	9	val10	0
10	0	val1	1
10	0	val14	1
11	11	val6	0
11	11	val8	0
12	12	val2	0
13	13	val13	0
14	14	val9	0
ANY RIGHT | bs = {{ block_size }}
4	4	0	val10
5	5	0	val6
6	6	0	val8
8	8	0	val1
9	9	0	val5
11	11	0	val11
12	12	0	val0
13	13	0	val2
13	13	0	val4
13	13	0	val9
14	14	0	val3
14	14	0	val7
ANY INNER | bs = {{ block_size }} | copmosite key
2	2	2	2	2	2	0	0
ANY LEFT | bs = {{ block_size }} | copmosite key
1	1	2	0	0	\N	val14	1
1	1	2	0	0	\N	val3	1
1	2	1	0	0	\N	val7	1
1	2	2	0	0	\N	val1	1
1	2	2	0	0	\N	val13	1
1	2	2	0	0	\N	val4	1
1	2	2	0	0	\N	val8	1
1	\N	1	0	0	\N	val0	1
1	\N	1	0	0	\N	val5	1
1	\N	2	0	0	\N	val10	1
2	2	1	0	0	\N	val11	1
2	2	1	0	0	\N	val2	1
2	2	1	0	0	\N	val6	1
2	2	2	2	2	2	val12	0
2	2	2	2	2	2	val9	0
ANY RIGHT | bs = {{ block_size }} | copmosite key
0	\N	0	1	1	1	1	val2
0	\N	0	1	1	1	1	val7
0	\N	0	1	1	2	1	val5
0	\N	0	1	1	\N	1	val0
0	\N	0	1	1	\N	1	val6
0	\N	0	2	1	1	1	val1
0	\N	0	2	1	1	1	val11
0	\N	0	2	1	2	1	val10
0	\N	0	2	1	2	1	val8
0	\N	0	2	1	\N	1	val3
0	\N	0	2	2	\N	1	val9
2	2	2	2	2	2	0	val4
{% endfor -%}
ALL INNER | join_use_nulls = 1
4	4	0	0
5	5	0	0
6	6	0	0
8	8	0	0
9	9	0	0
11	11	0	0
11	11	0	0
12	12	0	0
13	13	0	0
13	13	0	0
13	13	0	0
14	14	0	0
14	14	0	0
ALL LEFT | join_use_nulls = 1
1	\N	val7	1
2	\N	val3	1
2	\N	val5	1
4	4	val0	0
5	5	val12	0
6	6	val11	0
8	8	val4	0
9	9	val10	0
10	\N	val1	1
10	\N	val14	1
11	11	val6	0
11	11	val8	0
12	12	val2	0
13	13	val13	0
13	13	val13	0
13	13	val13	0
14	14	val9	0
14	14	val9	0
ALL RIGHT | join_use_nulls = 1
4	4	0	val10
5	5	0	val6
6	6	0	val8
8	8	0	val1
9	9	0	val5
11	11	0	val11
11	11	0	val11
12	12	0	val0
13	13	0	val2
13	13	0	val4
13	13	0	val9
14	14	0	val3
14	14	0	val7
ALL INNER | join_use_nulls = 1 | copmosite key
2	2	2	2	2	2	0	0
2	2	2	2	2	2	0	0
ALL LEFT | join_use_nulls = 1 | copmosite key
1	1	2	\N	\N	\N	val14	\N
1	1	2	\N	\N	\N	val3	\N
1	2	1	\N	\N	\N	val7	\N
1	2	2	\N	\N	\N	val1	\N
1	2	2	\N	\N	\N	val13	\N
1	2	2	\N	\N	\N	val4	\N
1	2	2	\N	\N	\N	val8	\N
1	\N	1	\N	\N	\N	val0	\N
1	\N	1	\N	\N	\N	val5	\N
1	\N	2	\N	\N	\N	val10	\N
2	2	1	\N	\N	\N	val11	\N
2	2	1	\N	\N	\N	val2	\N
2	2	1	\N	\N	\N	val6	\N
2	2	2	2	2	2	val12	0
2	2	2	2	2	2	val9	0
ALL RIGHT | join_use_nulls = 1 | copmosite key
2	2	2	2	2	2	0	val4
2	2	2	2	2	2	0	val4
\N	\N	\N	1	1	1	\N	val2
\N	\N	\N	1	1	1	\N	val7
\N	\N	\N	1	1	2	\N	val5
\N	\N	\N	1	1	\N	\N	val0
\N	\N	\N	1	1	\N	\N	val6
\N	\N	\N	2	1	1	\N	val1
\N	\N	\N	2	1	1	\N	val11
\N	\N	\N	2	1	2	\N	val10
\N	\N	\N	2	1	2	\N	val8
\N	\N	\N	2	1	\N	\N	val3
\N	\N	\N	2	2	\N	\N	val9
ANY INNER | join_use_nulls = 1
4	4	0	0
5	5	0	0
6	6	0	0
8	8	0	0
9	9	0	0
11	11	0	0
12	12	0	0
13	13	0	0
14	14	0	0
ANY LEFT | join_use_nulls = 1
1	\N	val7	1
2	\N	val3	1
2	\N	val5	1
4	4	val0	0
5	5	val12	0
6	6	val11	0
8	8	val4	0
9	9	val10	0
10	\N	val1	1
10	\N	val14	1
11	11	val6	0
11	11	val8	0
12	12	val2	0
13	13	val13	0
14	14	val9	0
ANY RIGHT | join_use_nulls = 1
4	4	0	val10
5	5	0	val6
6	6	0	val8
8	8	0	val1
9	9	0	val5
11	11	0	val11
12	12	0	val0
13	13	0	val2
13	13	0	val4
13	13	0	val9
14	14	0	val3
14	14	0	val7
ANY INNER | join_use_nulls = 1 | copmosite key
2	2	2	2	2	2	0	0
ANY LEFT | join_use_nulls = 1 | copmosite key
1	1	2	\N	\N	\N	val14	\N
1	1	2	\N	\N	\N	val3	\N
1	2	1	\N	\N	\N	val7	\N
1	2	2	\N	\N	\N	val1	\N
1	2	2	\N	\N	\N	val13	\N
1	2	2	\N	\N	\N	val4	\N
1	2	2	\N	\N	\N	val8	\N
1	\N	1	\N	\N	\N	val0	\N
1	\N	1	\N	\N	\N	val5	\N
1	\N	2	\N	\N	\N	val10	\N
2	2	1	\N	\N	\N	val11	\N
2	2	1	\N	\N	\N	val2	\N
2	2	1	\N	\N	\N	val6	\N
2	2	2	2	2	2	val12	0
2	2	2	2	2	2	val9	0
ANY RIGHT | join_use_nulls = 1 | copmosite key
2	2	2	2	2	2	0	val4
\N	\N	\N	1	1	1	\N	val2
\N	\N	\N	1	1	1	\N	val7
\N	\N	\N	1	1	2	\N	val5
\N	\N	\N	1	1	\N	\N	val0
\N	\N	\N	1	1	\N	\N	val6
\N	\N	\N	2	1	1	\N	val1
\N	\N	\N	2	1	1	\N	val11
\N	\N	\N	2	1	2	\N	val10
\N	\N	\N	2	1	2	\N	val8
\N	\N	\N	2	1	\N	\N	val3
\N	\N	\N	2	2	\N	\N	val9
FULL USING | join_use_nulls = 1
1	0	1
2	0	1
2	0	1
4	0	0
5	0	0
6	0	0
8	0	0
9	0	0
10	0	1
10	0	1
11	0	0
11	0	0
12	0	0
13	0	0
13	0	0
13	0	0
14	0	0
14	0	0
{% endfor -%}
